What do you mean by a distribution is homoscedastic (ie, $\sigma(Y|X = x) = \sigma$) in the context of simple linear regression?
why do we need this assumption in simple linear regression?
What will happen to the regession if a distribution is not homoscedastic?
As an example consider the following data-set:
The blue thick line is a linear fit to the red points. I added the dashed lines as a visual guide, but you can see that the dispersion around the prediction grows with $x$, that is, $\sigma$ is not constant. Moreover, probably $\sigma$ and $x$ are not independent.
If this is the case, then:
$$ \sigma(Y|X = x) \not= \sigma $$
This is an example where the homoscedastic assumption fails. In these situations you should be careful, since the best linear unbiased estimator (BLUE) of the coefficients is no longer provided by the standard ordinary linear square (OLS). See this link for further details.