Primary Key

[SirChick]

Hey guys quick question,

Is there way to always make sure inserting new rows take a unique number in the database but not necessarily doing an "auto increment"

Because say the 3rd row was deleted that leaves ID 3 available.. then i would rather the next newest insert to take ID 3 rather than the one at the very end.. which is what happens using auto increment.. how is this done?