ZF2 Zend\Db\Sql should know (for the MySQL platform) that OFFSET has to follow LIMIT.

zf2_sql_offset_limit_order.php

<?php

// ...

// This works:
$select->from($table)
	->group('id')
	->limit($limit)
	->offset($offset);

// This produces a MySQL exception:
$select->from($table)
	->group('id')
	->offset($offset)
	->limit($limit);