Sort WordPress Category Content by ACF Ranking

Modify WordPress category pages to sort posts by an existing ACF ranking field. The goal is to display posts with the highest ranking first, using a scale from 100 to 1. Changes should be made at the query level, preferably through pre_get_posts or JNews-compatible filtering, and should not alter the current category layout or functionality. The solution should ensure that updating a post’s ranking value automatically changes its position within the category. Please include a brief implementation plan and estimated effort. example category: https://excellentbusinessplans.com/category/freelancing/