DELIMITER $$

DROP PROCEDURE IF EXISTS `find`;
CREATE PROCEDURE `find` (IN `index` BIGINT UNSIGNED)
BEGIN 
	-- how to do ?
END $$

DELIMITER ;

DROP TABLE IF EXISTS `table`;
CREATE TABLE `table`
(
	`index` BIGINT UNSIGNED PRIMARY KEY,
	`value` TINYINT UNSIGNED NOT NULL INDEX,
	`minimum` TINYINT UNSIGNED NOT NULL INDEX,
	`maximum` TINYINT UNSIGNED NOT NULL INDEX
);

DROP TABLE IF EXISTS `table`;
CREATE TABLE `table`
(
	`index` BIGINT UNSIGNED PRIMARY KEY,
	`value` TINYINT UNSIGNED NOT NULL,
	`minimum` TINYINT UNSIGNED NOT NULL,
	`maximum` TINYINT UNSIGNED NOT NULL
);

INSERT INTO `table` VALUES
(1, 1, 3, 5),
(2, 4, 5, 5),
(3, 2, 2, 4),
(4, 5, 4, 3),
(5, 3, 1, 5);

SELECT `value`, `minimum`, `maximum`
FROM `table`
WHERE `index` = 1;

+-------+---------+---------+
| value | minimum | maximum |
+-------+---------+---------+
|     1 |       3 |       5 |
+-------+---------+---------+

SELECT `index`
FROM `table`
WHERE `index` != 1
AND `minimum` <= 1
AND 1 <= `maximum`
AND 3 <= `value`
AND `value` <= 5
LIMIT 1;

+-------+
| index |
+-------+
|     5 |
+-------+