Inspect row goals from TOP and EXISTS, read EstimateRowsWithoutRowGoal, and compare a targeted optimizer hint using actual plans.
Breaking Ties Deterministically: Why ORDER BY Needs a Tie-Breaker
Tied scores can come back in any order, which breaks paging. Here is the one column that fixes it.