I have some doubts that I would like to clarify, I have had bosses who have never wanted to work with ID Identity created by the same database manager, for the following reason that the correlative is lost. In my opinion the ID is not shown to the client so that I can worry about showing it or it can not be hidden.
There are developers who prefer to create their own ID giving it the size of the field like 0001, 000001, etc
Which of the two ways is good programming practice? Create your own ID type string with the size you want, is the time of the dinosaurs?