How to display events in chronological order?
Your screenprint and your generated SQL statement shows that your current view is FIRST sorted by node_created_order. Though from your question it seems that you want it to be sorted by "start date of the event".

So just delete the first field in your list of SORT CRITERIA and see what happens next ...