respect offset and limit query params for infinite lists

Closes #28030

See merge request !9540