MySQL 8.0

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

CREATE TABLE Numbers (
`Number` VARCHAR(50)
)
INSERT INTO Numbers 
VALUES
('0123 427 6465'),
('0123 1451'),
('01 23 46 47'),
('0123 945675'),
('07984 473456'),
('0845 46 47'),
('(012377) 5258'),
('0800 586931'),
('012 3668 6098'),
('0 1238592371');
SELECT * FROM Numbers

Number

0123 427 6465

0123 1451

01 23 46 47

0123 945675

07984 473456

0845 46 47

(012377) 5258

0800 586931

012 3668 6098

0 1238592371

SELECT n.number FROM Numbers n WHERE n.number REGEXP '^.*(0[ \t\r\n]*1[ \t\r\n]*2[ \t\r\n]*3).*|^.*(0[ \t\r\n]*7[ \t\r\n]*9[ \t\r\n]*8).*$'

number

0123 427 6465

0123 1451

01 23 46 47

0123 945675

07984 473456

(012377) 5258

012 3668 6098

0 1238592371

`Number`
`0123 427 6465`
`0123 1451`
`01 23 46 47`
`0123 945675`
`07984 473456`
`0845 46 47`
`(012377) 5258`
`0800 586931`
`012 3668 6098`
`0 1238592371`

`number`
`0123 427 6465`
`0123 1451`
`01 23 46 47`
`0123 945675`
`07984 473456`
`(012377) 5258`
`012 3668 6098`
`0 1238592371`