MySQL 8.0

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

select version();


version()


8.0.27


CREATE TABLE foo(
  `id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `id_Verse` TEXT
);

INSERT INTO foo(id_Verse)
VALUES 
   ('[991]'),
   ('[1070]'),
   ('[991][992][1004][1007]'),
   ('[991][992][1004][1007][1010]'),
   ('[1007][1008]'),
   ('[989][991]'),
   ('[9910]'),
   ('[964]'),
   ('[1007]');
SELECT * FROM foo
WHERE id_Verse REGEXP '\\[(991|1007)\\]';


id
id_Verse


1
[991]

3
[991][992][1004][1007]

4
[991][992][1004][1007][1010]

5
[1007][1008]

6
[989][991]

9
[1007]

id	id_Verse
1	[991]
3	[991][992][1004][1007]
4	[991][992][1004][1007][1010]
5	[1007][1008]
6	[989][991]
9	[1007]