Does the order of the columns matter in the Upload CSV file? Is adding all the columns mandatory in the CSV while uploading?

Yes, once the sync is created based on the existing excel/CSV file in the FTP host, all future files should have the same columns in the same order.
When creating a sync, you can choose which columns you want to import from. The remaining columns (not selected in the sync mapping) will be ignored.