I don't think so, paging in database adapters, across the board, is already a non-standard thing.  Seeing as though this is strongly a mysqlism, I think it makes the most sense to do this in the MySQL decorator.  For it to be in Select, there would have to be a VERY strong argument that this particular workflow applies to most of the other popular DB platforms: postgres, sqlite, SQL Server, Db2 and Oracle.