Method for displaying the line number when Query in SQL Server

Select no = identity (int, 1, 1), * INTO #Temptable from Tablename --Order by Sortfield

Select * from #temptable --where no> = 6 and no <10

Drop Table #Temptable