Yes one way is using Over clause and Rank() to simulate with ties functionality:
select * from(
select Id, [Name], rank() over(order by Id) as R
from #tbl) A
where A.R = 1;