Can you please clarify the intended behavior? The formula from your message does not seem to be correct.
Generally, when you're pulling a sorted list which contains identical items then the order of those identical items is not guaranteed. You will have to also sort by other columns. Example:
If your formula is ClearCollect(ColName ,SortByColumns( MyTable, "aaa", Ascending))
... and MyTable contains identical values in the "aaa" column then the order of those values in the ColName will not be guaranteed. In order to get the expected order, you will also have to sort by another column (ID or DateCreated for example).