Repeating sequence within a group of data

I am having difficulty in writing one SQL query. The need I have is with in a group of rows I have to assign a sequence for each row for which I can simply use rank to write my query. However, I need to also use the lower limit and upper limit of the sequence number and if the upper limit is crossed, I have to start again from lower limit.

I can number each row in the group using either row num or rank. But this above requirement is almost done but for some rows, there is a wrong number assigned.

I will try explaining using an example

Example query I tried but its not giving the complete correct result. Could anyone provide me some pointers to correct this code?

with mylimits as
 (select 5 lowerlimit, 8 upperlimit from dual),
mydata as
 (SELECT Rownum A FROM Dual CONNECT BY Rownum <= 15)
select m.a,
       case
         when m.a = mod(m.a, l.upperlimit - l.lowerlimit + 2) then
          m.a + l.lowerlimit - 1
         when m.a <> mod(m.a, l.upperlimit - l.lowerlimit + 2) then
          mod(m.a, l.upperlimit - l.lowerlimit + 2) + l.lowerlimit
       end rep_seq
  from mydata m, mylimits l

I think you can define the limit and calculate the position within the cycle using mod(m.a - 1, l.upperlimit - l.lowerlimit + 1) and then adjust again to start from the lower limit.

Example fiddle

  WITH mylimits AS (
    SELECT 5 AS lowerlimit, 8 AS upperlimit FROM dual
),
mydata AS (
    SELECT ROWNUM AS a FROM dual CONNECT BY ROWNUM <= 15
)
SELECT m.a row_num,
       mod(m.a - 1, l.upperlimit - l.lowerlimit + 1) + l.lowerlimit AS rep_seq_5_to_8
FROM mydata m, mylimits l
ORDER BY m.a;

Output