That is not a worthwhile goal. You should never care what the IDs are and you should
never change them. What are you
really trying to accomplish?
If you simply want to have a user-friendly ordering for display you could do something like the following:
CREATE TABLE y ( RN INTEGER IDENTITY , ID INTEGER , Name NText )
INSERT INTO y ( ID , Name ) SELECT ID , Name FROM x ORDER BY ID
SELECT * FROM y
DROP TABLE y
In full Sql Server I'd use the ROW_NUMBER function, but CE doesn't have it. Nor does it have temporary tables. Not even SELECT/INTO.