basically: the database server knows that the field should have unique numbers, so it keeps track of what has been used, and just assigns the next available unique number to the field.

if you specify a number for the field it may or may not work, depending on whether the value has been used before, and variaous database setup issues (I'm not sure what though, I've only been back from holiday a few days!).