recreate row IDs in sorted table

I built word2vec dictionary as a mysql table. There is millions of rows like this: ID CREATED UPDATED KEYWORD COUNT NUMPYBLOB NUMPYBLOB ... ... 121201 2018-03-08 04:01:23 2018-03-08 21:54:34 iulius 32 121202 2018-03-08 04:01:23 0000-00-00 00:00:00 admonitivo 1 121203 2018-03-08 04:01:23 0000-00-00 00:00:00 lulius 1 121204 2018-03-08 04:01:23 2018-03-08 16:56:14 lugh 20 121205 2018-03-08 04:01:23 2018-03-08 22:34:31 contingencias 66 121206 2018-03-08 04:01:23 2018-03-08 19:50:34 liberándola 12 121207 2018-03-08 04:01:23 0000-00-00 00:00:00 agostillo 1 121208 2018-03-08 04:01:23 2018-03-08 22:47:39 autonomista 212 121209 2018-03-08 04:01:23 2018-03-08 05:54:12 astrológicamente4 121210 2018-03-08 04:01:23 2018-03-08 18:54:43 redondearse 5 Now I want to sort this table by word occurrence counter (COUNT) and when the table is sorted rewrite autoincremental ID row from zero to X in order to word ocurrency goes down. I can't use COUNT column as primary key, because it is varies continuously and not unique. How I can do it?