Enable sorting by lock states in rule tables

[maany]

Description

Users should be able to sort rules by their lock states to quickly group and find rules in specific states. This feature will improve rule management and troubleshooting workflows.

Current Behavior

• Lock states column may not be sortable
• Users cannot group rules by their current state
• Difficult to find all rules in a specific state

Proposed Solution

• Enable click-to-sort on the lock states column
• Support ascending/descending sort order
• Maintain sort state during page navigation

Implementation Details

1. Add sorting functionality to lock states column header
2. Implement sort logic for lock state values
3. Define sort order for different states (e.g., Error > Stuck > Replicating > OK)
4. Add visual indicators for sort direction
5. Persist sort preferences if applicable
6. Ensure sorting works with pagination/scrolling

Acceptance Criteria

• Lock states column header is clickable for sorting
• Clicking toggles between ascending/descending/unsorted
• Visual indicator shows current sort direction
• Sorting groups rules by lock state effectively
• Sort state persists during session

Parent Issue

• [EPIC: Release 39] UX improvements #621