Fix for Incorrect Results in Queries with OFFSET and WHERE Clauses

Queries with OFFSET clause in subquery and WHERE clause in outer query might return incorrect result, it's fixed. Fixes #40416. #41280 (Alexander Tokmakov).