Show the next user id in WordPress

In a recent project I have to show and use the next user_id as username ( I know it is a bad decision, but this is how the client wants it). I would usually use $wpdb->insert_id but that works only if you already inserted a row before. So I had to use MySQL SHOW TABLE