I want to add id to my table in a sorted way

My table is like this

   release
   b
   c
   a
   e
   f
   q

I want to add id according to their name in a sorted way from a to z,like this

   release    id
   b          2
   c          3
   a          1
   e          4
   f          5
   q          6

How to do this?