I’d agree that yyy.mm.dd is probably the best for sorting reasons, but imo dd.mm.yyyy also has at least some logic in an everyday setting. Usually the order of relevance for everyday appointments is the day, then month, then year. Oftentimes the year has no informational value at all, since it is implied, e.g. for an upcoming birthday.
Of course you also need to know the month, but similar to the year i would argue that there are plenty of times where the month is evident from context. So the informational value is lower than the day.
I don’t want to argue that this is an absolute thing, but i’d say that quantitatively there are more times where you only need the day compared to very few times where you only need the month for example.