Create a ranking column

Hello,

Please see the attached workbook.

can you please make the purple area be a ranking system based on the cities' scores in the orange section.
As more cities and scores are added in the orange section, the purple section should update automatically.

Thank you