The sorting options in the report builder aren’t persistent through pagination.
We can contribute with a PR but needs some help from frappe team that is involved in the new datatables.
Issue with gif: https://github.com/frappe/frappe/issues/7766
Thanks