MS SQL : Append new column with sequential numbers/id

<h3>-- PROPOSED:</h3>
<pre>
SELECT TOP 1000 [RankId]
      ,[RankCode]
      ,[RankName]
      ,[ShortName]
    ,rt.RankTypeCategoryCode
  FROM
  [eCrewDos].[Crewing].[Ranks] r
  INNER JOIN [Crewing].[RankTypes] rt ON rt.RankTypeCode = r.RankType
WHERE r.[IsDeleted] = 0
ORDER BY rt.RankTypeCategoryCode, RankCode --SortOrder
</pre>
<br/><br/><br/>
<h3>-- PROPOSED with Row Number:</h3>
<pre>
SELECT TOP 1000 [RankId]
 ,[RankCode]
 ,[RankName]
 ,[ShortName]
 ,rt.RankTypeCategoryCode
 , ROW_NUMBER() OVER(ORDER BY rt.RankTypeCategoryCode ASC, RankCode ASC) AS Row#
FROM
 [Crewing].[Ranks] r
 INNER JOIN [Crewing].[RankTypes] rt ON rt.RankTypeCode = r.RankType
WHERE r.[IsDeleted] = 0
ORDER BY rt.RankTypeCategoryCode, RankCode --SortOrder
</pre>