VS 2010 How To Re-count ID Column After Delete Row

I Have a database with SqlCeConnection("Data Source=|DataDirectory|Database1.sdf").

The first column is named ID and Data type "int". For example i have 3 records:

ID Name
1 John
2 Mike
3 Steven

When i delete the record with ID 2 it happen this in ID column:

ID Name
1 John
3 Steven

Here is my problem: I Like when i delete a record the ID column re-count the records and show this in ID column:

ID Name
1 John
2 Steven

Is that possible with SqlCe command?

command i mind like: cmd = New SqlCeCommand("Do something", con)