auto generated value for primary key with primary numbers : I want to make auto generated value for primary key with primary numbers 

for example I have this table where `id` is the primary key:

 tags_table :
    
    id | name
    ---------
    2  | some_text
    3  | some_text
    5  | some_text
    ...
    997| some_text

when ever new row inserted it will get the next primary number for the `id` .

**is** there a way to achieve this in mysql or any other RDBMS ? if so **how** ?

