How to return the highest value in a sequence for each ID unless one has been skipped, with SQL?

I want to return the columns listed below but would like it grouped by JobNumber and only return the maximum StageNum so long as it has not skipped any stages.

For example, my table currently looks like this:

ID	Stage	StageNum	Date
104	Released	10	2022-02-07
104	Slab	20	2022-02-18
104	Frame	30	2022-03-07
104	Mechanicals	42	2022-03-10
105	Released	10	2022-02-07
105	Slab	20	2022-02-18
106	Released	10	2022-02-07
106	Slab	20	2022-02-18
106	Frame	30	2022-03-04
106	Cornice	40	2022-03-08

And the result should look like this with ID 104 returning StageNum 30 instead of 42 since StageNum 40 was skipped:

ID	Stage	StageNum	Date
104	Frame	30	2022-03-07
105	Slab	20	2022-02-18
106	Cornice	40	2022-03-08

I can return the highest value by grouping by ID and selecting MAX(StageNum) but do not know how to account for the skipped stages.

Answer

Provided there exists the stages table

select * into stages
from(
  values
   ('Released', 10),
   ('Slab',     20),
   ('Frame',    30),
   ('Mechanicals', 42),
   ('Cornice',     40)
) t(Stage,  StageNum)

You can compare positions requierd with the operations

select top(1) with ties ID, Stage, StageNum, Date
from (
  select t.ID ,t.StageNum, t.Date, stn.Stage, stn.spos, row_number() over(partition by ID order by t.StageNum) tpos
  from tbl t
  join (
     select StageNum, Stage, row_number() over(order by StageNum) spos
     from stages
  ) stn on stn.StageNum = t.StageNum
) t
where tpos=spos
order by row_number() over(partition by ID order by StageNum desc)