Should order of column in where clause be same as the index order?
So, my question is does the order of columns in Where clause matters


No. The order of columns in the WHERE clause does not matter at all.