I use this to obtain from regular table, but it doesn't work for temporary table

SELECT AUTO_INCREMENT

FROM information_schema.tables

WHERE table_name = 'table_name'

AND table_schema = DATABASE( ) ;