It depends on the implementation of the database (no mainstream I know, except for an improbable bug ), mostly it does not matter, it will find the best way to use the index, at least in simpler cases like this. In more complex cases the proper use of the index in the most naive DBs may not occur. It is true that "order" in more complex cases is already a complicated concept to define.
This is not valid for any query, there are situations that the order will influence whether or not it can use the index for performance.
Generally you should create the necessary indexes for the queries that you use in the code and in fact it is proven that there are gains. Remembering that creating an index incurs an extra cost, especially for writing, but it also affects reading by having more data to "dirty" the cache.
It's always worth the maximum that performance should be tested, a lot of it's worth here is not worth it, in database this is more true because even the volume and distribution of data affects whether it will work well or not. >