Auto Increment - Order/user numbers not changing
The users table does not work with AUTO INCREMENT in Drupal 7.
Instead, the ids are generated in PHP.

See What could cause uids to not be numbered consecutively?