Assuming ID is an identity column, I would do something like this:
SELECT TOP 10
[ID] ,[Name]
FROM [dbo].[myTable]
ORDER BY ID DESC
As you are asking for "last" you are imposing order - the whole thing would be meaningless without ordering the result.
Best regards
Espen Harlinn