Something like this:

with basedata as (

select

*, rn = row_number() over (order by part_no)

from dbo.voters

)

update basedata set

rec_num = rn;

Edit: Removed extra order by in CTE