MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table ticket_statuses (
  ticketStatus_Id integer auto_increment primary key,
  ticket_Id integer not null,
  status_Id integer not null,
  extra text
);
insert into ticket_statuses (ticketStatus_Id, ticket_Id, status_Id, extra) values
(1,                 1,            1, 'one'),
(2,                 1,            2, 'two'),
(3,                 1,            3, 'three'),
(4,                 2,            1, 'four'),
(5,                 3,            1, 'five'),
(6,                 3,            2, 'six'),
(7,                 4,            1, 'seven'),
(8,                 4,            2, 'eight'),
(9,                 4,            3, 'nine'),
(10,                4,            4, 'ten'),
(11, 5, 3, 'eleven');
  select ts1.*
  from ticket_statuses ts1
  left outer join ticket_statuses ts2
    on  ts1.ticket_Id = ts2.ticket_Id
    and ts1.status_Id < ts2.status_Id
  where ts2.ticketStatus_Id is null


ticketStatus_Id
ticket_Id
status_Id
extra


3
1
3
three

4
2
1
four

6
3
2
six

10
4
4
ten

11
5
3
eleven


with max_statuses as (
  select ts1.*
  from ticket_statuses ts1
  left outer join ticket_statuses ts2
    on  ts1.ticket_Id = ts2.ticket_Id
    and ts1.status_Id < ts2.status_Id
  where ts2.ticketStatus_Id is null
)
select ms.*
from max_statuses ms
join ticket_statuses ts
  on  ms.ticket_id = ts.ticket_id
  and ts.status_id = 2;


ticketStatus_Id
ticket_Id
status_Id
extra


3
1
3
three

6
3
2
six

10
4
4
ten