This can be done using clauses like I outlined here https://support.advancedcustomfields.com/forums/topic/sort-by-one-field-and-then-by-another/#post-52147
Edit: maybe not exactly like I outlined there, but the principle is the same and you should be able to do this using clauses.