Try something like

select

Field1

, Field2

, DENSE_RANK () OVER (ORDER BY Field1) AS SeqNo

FROM YourTable