SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (ID int, Name varchar(10), NumberMin int, NumberMax int);
insert into t (ID, Name, NumberMin, NumberMax) values (13, 'John', 10, 14);
1 rows affected

with
x as (
  select ID, Name, NumberMin, NumberMax, NumberMin as cur from t
  UNION ALL
  select ID, Name, NumberMin, NumberMax, cur + 1
  from x
  where cur < NumberMax - 1
)
select * from x


ID
Name
NumberMin
NumberMax
cur


13
John
10
14
10

13
John
10
14
11

13
John
10
14
12

13
John
10
14
13