>If you write code that'd make the assumption a reality in the first place then it works out as perfect. If data with physical order does not match the time order you already have problem in data you have. Proper query doesn't help you identifying that situation.

You again making assumption. If physical order does not match the time order it may or may not be a problem. Anyway, the goal of above mentioned query is to get correct result not to find problems with data.