Why my auto increment field no longer works after row 127?

Apply OS: Window, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for MariaDB, Navicat Premium

Apply Navicat Version No.: All

If you have used tinyint for your auto-increment field, its largest value will only be 127.