I have a table with 9 records, my identities are in the order of 1 to 9, when I insert a new record in the table automatically a new ID is set, but it is set to the value 30 instead of with the next number which in this case would be 10 (I have 9 records). If by chance I am inserting records the ID of them goes on to follow the order is stand 31, 32, 33 ...
I do not know how to fix this problem.