This is a bad idea: if you are using an Identity field for your I'd! Then there could be other fields using this informally as a foreign key, so SQL does not reuse or reassign numbers.
Instead, return the rownumber
SELECT ROW_NUMBER() OVER (ORDER BY id) as RowNum, [name], city FROM MyTable