MySQL: function returning select with offset parameter

Question

Function get_summ must return a value from SELECT with specified OFFSET which is passed as parameter:

DELIMITER $$
CREATE FUNCTION get_summ(i INT, o INT)
    RETURNS INT
BEGIN    
    RETURN (SELECT summ FROM orders WHERE id = i LIMIT 1 OFFSET o);
END$$
DELIMITER ;

This gives syntax error near 'o').

Is that possible with MySQL?