select top 1 id from NomeTabella order by id desc

ciao