If I use any other column which is in NCI (& not PK), then this is a seek.
NCI is same in both situations. Difference is only is Row_Number order by column. Please check the attached two execution plans. One is Row_Number with PK & second one is Row_Number with any other column.
one shows SCAN & another one shows SEEK. Difference is only in Row_Number order by column.