if you're asking how to delete an account: DELETE FROM login_accounts WHERE id = <id of account to delete>;
(don't forget the WHERE part
)
If you mean when you insert an account and the id it gives you is not in sequence you can use (from readme):
update login_accounts set id='whateveryouwant' where name='usersname';
to move it to.