Select roads that are between FROM and TO
select *
from road
connect by (prior to_ = from_ and from_ != 'Street V')
start with name_ = 'Street B' and from_ = 'Street II'
;

   ROAD_ID NAME_      FROM_      TO_              SORT
---------- ---------- ---------- ---------- ----------
         5 Street B   Street II  Street III        200
         6 Street B   Street III Street IV         300
         7 Street B   Street IV  Street V          400


Answer for the updated question:

select road_id, name_, from_, to_, sort
from
(
  select road_id, name_, from_, to_, sort, 
  row_number() over (order by sort) as rn from road
  where name_ = 'Street B'
)
connect by (prior rn + 1 = rn and from_ != 'Street VIII')
start with from_ = 'Street II'
;

   ROAD_ID NAME_           FROM_           TO_                   SORT
---------- --------------- --------------- --------------- ----------
         9 Street B        Street II       Street III             200
        11 Street B        Street III      Street IV              300
         3 Street B        Street VI       Street VII             600
         7 Street B        Street VII      Street VIII            700