Why you need function ? You can achieve this using stored procedure.
CREATE PROC SearchRecordInAllTableById
(
@Id BIGINT
)
AS
BEGIN
IF EXISTS (SELECT Id FROM TABLE1 WHERE ID=@Id)
BEGIN
RETURN 1
END
IF EXISTS (SELECT Id FROM TABLE1 WHERE ID=@Id)
BEGIN
RETURN 1
END
RETURN 0
END