SQLite: How to UPDATE column using count(*) range?

I'm not sure I'm using right terminology here.

Basically I want to update entire "id" column using count(*) [485] as a delimiter, in an ascending order, so the resulting row value will correspond with rownumber (not the rowid).