As the title said ,
If I had a
WHERE table_name = 'table_name'
AND table_schema = DATABASE( ) ;
SHOW TABLE STATUS LIKE 'table_name'
It is unclear whether you want to retrieve the last inserted id right after the insert or at any given time so I will answer the latter as it is the least straight-forward.
As you write yourself, the last inserted id is not stored with the table itself but rather the table information_schema.tables which is why you cannot use the model to retrieve this information. You can however use the query builder in Laravel to do this.
$last_insert_id = DB::table('information_schema.tables') ->where('table_name', $table_name) ->whereRaw('table_schema = DATABASE()') ->select('AUTO_INCREMENT')->first();