This type of issue has been discussed here a couple times before. See Race condition in auto-incrementing value for one of the discussions.
Start there and see if that answers some of your questions. Feel free to reply here if you want to discuss any of those ideas in more detail.