title: make primary key id always in sync with row number
body: <p>once I set this column to primary key auto_increment, then it increases the "id" by one each time, even if i deleted the previous rows, so the first row id may start with 4 or 40, but I hope the id could always go along with the row number, how can I manage to do that in mysql? </p>