HHH-18461 Fix native query doesn't respect `query.setFirstResult(0)`

[quaff]

Align to JPQL query, generated sql should contain offset ? rows and pass 0 as parameter.

[Please describe here what your change is about]

---

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license and can be relicensed under the terms of the LGPL v2.1 license in the future at the maintainers' discretion. For more information on licensing, please check here.

---

https://hibernate.atlassian.net/browse/HHH-18461