If it is house number $x$ in a street of $y$ houses, we have $$\frac{x(x-1)}{2}+x+\frac{x(x-1)}{2}=\frac{y(y+1)}{2}$$ which simplifes to $$(2y+1)^2-8x^2=1\ .$$ This can be solved by computing the continued fraction $$\sqrt8=2+\frac{1}{1+{}}\frac{1}{4+}\frac{1}{1+{}}\frac{1}{4+\cdots}\ .$$ The table of convergents is $$\matrix{&&2&1&4&1&4&1&4&1&4&\cdots\cr 0&1&2&\color{red}{3}&14&\color{red}{17}&82&\color{red}{99}&478&\color{red}{577}&2786&\cdots\cr 1&0&1&\color{red}{1}&5&\color{red}{6}&29&\color{red}{35}&169&\color{red}{204}&985&\cdots\cr}$$ The pairs beneath the second-last entry in each period (that is, in this case, beneath the $1$s) are marked in red. They give the integer values of $2y+1$ and $x$ satisfying the equation. For example we have firstly $y=1$, $x=1$ (the trivial solution - house numbers on both sides of $1$ add up to $0$). Then $y=8$, $x=6$ as you observed. The fourth solution is Ramanujan's.