using your simplified sample data:
table name: figure_lines
Line_Id | Line_Name | Interest1
1 | John | 2
2 | Bob | 1
I was able to get the desired result using the following query:
SELECT figure_lines.line_name, I2.line_name
FROM figure_lines
INNER JOIN figure_lines AS I2 ON I2.line_id = figure_lines.interest1