[backport v2.9.next1] Server-side Pagination: Sorting: Cluster Dash: Newly created resource populates at bottom of list; sort order preference ignored

[github-actions]

This is a backport issue for #11498, automatically created via GitHub Actions workflow initiated by @richard-cox

Original issue body:

Setup

• Rancher version: v2.9-head
• Rancher UI Extensions:
• Browser type & version:

Describe the bug
Newly created resource populates at the bottom of the resource list (config maps, secrets) when server-side pag is enabled; sorting preference is ignored.

To Reproduce

1. go to Global settings > feature flags > enable ui-sql-cache
2. go to Global settings > performance > enable `Server-sdie Pagination'
3. go to cluster dash
4. click ConfigMaps in side nav
5. notice secrets list is sorted by name by default
6. create config map
7. notice newly created secret is not sorted correctly

Result
sort order is preference is ignored.

Expected Result
sort order is not ignored.

Screenshots
https://github.com/user-attachments/assets/c6df7482-1225-43bc-889e-7bb239633ed5

Additional context

[richard-cox]

Gonna keep things neater and use backport label in upstream ticket. The backport version also might change