SELECT
  *,
  ROW_NUMBER() OVER (ORDER BY SomeColumn) as TempID
FROM YourTable
WHERE...