If the table is empty or you are okay with deleting the data, you can truncate it. Truncating automatically resets the auto-increment value. Use the following SQL to delete all rows in the table and reset the auto-increment counter to 1.
TRUNCATE TABLE table_name;