(you don't have to strictly follow this form)

**Describe the bug**
When using `ORDER BY column_name COLLATE 'en'`, `COLLATE` is ignored if `column_name` is the primary key
 
**How to reproduce**
* version 21.1.2
* `CREATE TABLE` statements for all tables involved:
```
CREATE TABLE test.test_collation
(
    `v` String,
    `v2` String
)
ENGINE = MergeTree
ORDER BY v
SETTINGS index_granularity = 8192
```
* Sample data:
```
insert into test.test_collation values ('A', 'A')
insert into test.test_collation values ('B', 'B')
insert into test.test_collation values ('C', 'C')
insert into test.test_collation values ('a', 'a')
insert into test.test_collation values ('b', 'b')
insert into test.test_collation values ('c', 'c')
```
* Queries to run that lead to unexpected result
Primary key
```
SELECT *
FROM test.test_collation
ORDER BY v ASC COLLATE 'en'

Query id: fa84ae7a-abe7-4886-99cd-eba7ad5d5fc4

┌─v─┬─v2─┐
│ A │ A  │
│ B │ B  │
│ C │ C  │
│ a │ a  │
│ b │ b  │
│ c │ c  │
└───┴────┘
```
Separate column
```
SELECT *
FROM test.test_collation
ORDER BY v2 ASC COLLATE 'en'

Query id: 04401f85-3cb2-442c-8c89-e3328d1615cd

┌─v─┬─v2─┐
│ a │ a  │
│ A │ A  │
│ b │ b  │
│ B │ B  │
│ c │ c  │
│ C │ C  │
└───┴────┘
```

**Expected behavior**
Both of these queries to return the rows in the same order

const ASTTablesInSelectQueryElement & join_element, const ColumnsWithTypeAndName & left_sample_columns)
{
    
    auto join_hash = join_element.getTreeHash();
    String join_subquery_id = toString(join_hash.first) + "_" + toString(join_hash.second);
    SubqueryForSet & subquery_for_join = subqueries_for_sets[join_subquery_id];
    
    if (!subquery_for_join.join)
        subquery_for_join.join = tryGetStorageJoin(syntax->analyzed_join);
    if (!subquery_for_join.join)
    {
        
        ExpressionActionsPtr joined_block_actions = createJoinedBlockActions(getContext(), analyzedJoin());
        Names original_right_columns;
        if (!subquery_for_join.source)
        {
            NamesWithAliases required_columns_with_aliases = analyzedJoin().getRequiredColumns(
                joined_block_actions->getSampleBlock(), joined_block_actions->getRequiredColumns());
            for (auto & pr : required_columns_with_aliases)
                original_right_columns.push_back(pr.first);
            /** For GLOBAL JOINs (in the case, for example, of the push method for executing GLOBAL subqueries), the following occurs
                * - in the addExternalStorage function, the JOIN (SELECT ...) subquery is replaced with JOIN _data1,
                *   in the subquery_for_set object this subquery is exposed as source and the temporary table _data1 as the `table`.
                * - this function shows the expression JOIN _data1.
                */