Explaining how I achieved in 2 steps
Step 1. Use the Multi-row Formula tool
Create New Field - Rank
Num rows - 1
Expression
if([count]=[Row-1:count])
then [Row-1:Rank]
else [Row-1:Rank]+1
endif
Step 2: Use Filter to sort only up to Rank 5
Result is achieved