1.) What do you plan to do if you ever hire a second person with the same first name?

2.) This isn't typical of how you design databases.   There should be a separate table for the names of the people involved, and a foreign key relationship should exist between the base table and the table of names and other related values.   As to getting a sequence of numbers for the various rows, it's usually best to use a datetime column to represent the order in which the values were inserted, and then use the ROW_NUMBER() function to derive a numeric ordering whenever it's needed.