declare @yourtable table (name varchar(10),val int);
declare @fromval int;
declare @toval int;

set @fromval=6;
set @toval=8;

insert into @yourtable
 values ('Jim',4)
       ,('John',5)
       ,('Tom',6)
       ,('Julie',7)
       ,('Rich',8)
       ,('Rob',9)
;

select a.*
  from @yourtable as a
       inner join (select max(val) as val
                     from @yourtable
                    where val<@fromval
                  ) as b
               on b.val<=a.val
 where a.val<=@toval
 order by a.val
;