ID incrementing for multiple users - please help

[eluser]phester[/eluser]
These suggestions area all really good. But I thought there would be a more elegant solution that will not require me to manually increment. Holding separate tables or modifying the DB for each new user is not too elegant either in my eyes.

Thank you all for your help. But is there a more elegant solution out there?