CODE EXAMPLE FOR PHP

laravel eloquent get current sequence value

$statement = DB::select("SHOW TABLE STATUS LIKE 'users'");
$nextId = $statement[0]->Auto_increment;