MariaDB reset table index value?
On a related note:  There are several ways that auto_inc ids can be "burned".  For example, INSERT IGNORE will allocate as many ids as it could need, but waste any that it fails to use.  Ditto for IODKU.  REPLACE (which is mostly obviated by IODKU) is effectively DELETE + INSERT, hence always burns id(s).

Whereas changing the datatype to a bigger INT will keep you going, it may be better to worry about the "burning" of ids.  That is, find and fix the code.

Normalization tends to burn often.  Here's an approach to avoid wasting ids: http://mysql.rjweb.org/doc.php/staging_table#normalization