with daily_temper as (
select   'Москва' temper  from dual
union all
select   'Санкт-Петербург' temper  from dual
union all
select   'Воронеж' temper  from dual
union all
select   'Абакан' temper  from dual
union all
select   'Челябинск' temper  from dual
)


select case when r = 1 then t1
            when r = 3 then t2
            when r = 2 then t1
              end
from(
select dt.temper as t1,dt2.temper as t2
       ,rank()over(order by  dt.temper) as r
from (
select temper
from daily_temper 
where temper  in ('Москва','Санкт-Петербург')
) dt
full join (
select temper
from daily_temper 
where temper not in ('Москва','Санкт-Петербург')
) dt2 on dt.temper = dt2.temper
order by dt2.temper desc
)t