Powershell Script - Sorting the output in a logical order

Good Afternoon,

I currently have a power shell script that extracts data from a CSV source file and writes a new output file.

Script -

CSV Source File:

Output File:

I want to able to the sort the output file into the following order based on the headings below

1. Order Number
2. Please enter either the Plot Number, Garage Number or an area where the work is being done?
3. the following scaffolding which is either

So the new output file will look this

"HV_000024_1150980","189 188 plot ","Handing-Over"