@cobalt yeah it's bad for user-facing IDs for those reasons (and leaking the amount of rows, etc), but every table is not readable by users (or you can have a situation like my $dayjob codebase where those things don't matter at all)
sequential keys get you more efficient queries in some databases, I don't know mysql, they're not bad as a hard rule