Sqlite-Python Restar autoincremental ID

Hi guys! I’m trying to update (restar) the auto-incremental ID in my table, but my code doesn’t work. No errors, just, nothing.

I Have:
(1, ‘Adam’, ‘Smith’)
(2, ‘David’, ‘Ricardo’)
(3, ‘Linus’, ‘Torvals’)
(4, ‘Ada’, ‘Lovelace’)

if i delete row 2 :
(1, ‘Adam’, ‘Smith’)
(3, ‘Linus’, ‘Torvals’)
(4, ‘Ada’, ‘Lovelace’)

But i would like to have a function to update the ID:

(1, ‘Adam’, ‘Smith’)
(2, ‘Linus’, ‘Torvals’)
(3, ‘Ada’, ‘Lovelace’)
CODE:

def update_sql():
    conn = sqlite3.connect('people.db')
    c = conn.cursor()

    c.execute("""UPDATE `sqlite_sequence` SET `seq` = 0 WHERE `name` = 'people'""")

    conn.commit()
    c.close()