MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();

VERSION()

8.0.30

SET @@SESSION.`information_schema_stats_expiry` = 0;
DROP TABLE IF EXISTS `temp_order`;
CREATE TABLE IF NOT EXISTS `temp_order` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY
);
SELECT `auto_increment`
FROM `information_schema`.`tables`
WHERE TABLE_NAME = 'temp_order'
AND TABLE_SCHEMA = DATABASE();

AUTO_INCREMENT

null

SHOW CREATE TABLE `temp_order`;

Table
Create Table

temp_order
CREATE TABLE `temp_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

INSERT INTO `temp_order`
VALUES (NULL), (NULL), (NULL), (NULL), (NULL), (NULL);

Records: 6  Duplicates: 0  Warnings: 0

SELECT MAX(`id`)
FROM `temp_order`;

MAX(`id`)

6

SHOW CREATE TABLE `temp_order`;

Table
Create Table

temp_order
CREATE TABLE `temp_order` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

SELECT `auto_increment`
FROM `information_schema`.`tables`
WHERE TABLE_NAME = 'temp_order'
AND TABLE_SCHEMA = DATABASE();

AUTO_INCREMENT

7