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');

Records: 10  Duplicates: 0  Warnings: 0

SELECT `number` 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 `number` FROM Numbers WHERE LEFT(REPLACE(REPLACE(REPLACE(`number`, '(', ''), ')', ''), ' ', ''), 4) IN ('0123', '0798') 

number

0123 427 6465

0123 1451

01 23 46 47

0123 945675

07984 473456

(012377) 5258

012 3668 6098

0 1238592371