How does column order matter in a composite index?

Write or say your answer first, then compare it with the model answer.