Updating autoincrement column in Sqlite

I have an application for record keeping. I want to ask on how to do this. Example I have 4 records and its id is 1 2 3 4. Then I delete record 2. What I want is I want my record to become 1 2 3 but what really happens is 1 3 4. Also if I add a new record, I want it to become 1 2 3 4 but what happens is 1 3 4 5. Please let me know how to do it. Also this row has auto increment attribute