I have tried a lot but i do not seem to find an equation. Question is the following:
Find an equation of the specified curve, that is, of the locus of points the sum of whose distances from the points $(2,3)$ and $(4,1)$ is $8$.
I first tried to translate and rotate the axis to see the ellipse like its center lies on the origin $(0,0)$. It seemed to be tough. I know I can use the general equation with center $(h,k)$ but then there will not be any rotation though the major axis is rotated.

You write that you had considered a general ellipse equation with center somewhere other than the origin, but there was no rotation involved. It sounds to me like your “general” equation wasn’t general enough. Including an axis rotation, a general equation for an ellipse has the form $${((x-h)\cos\theta+(y-k)\sin\theta)^2\over a^2}+{(-(x-h)\sin\theta+(y-k)\cos\theta)^2\over b^2} = 1. \tag1$$ Now, the semimajor axis length $a$ is half of the constant distance to the foci, and for the semiminor axis length we have $b^2=a^2-c^2$, where $c$ is half the distance between the foci, so finding the two denominators is easy. The center $(h,k)$ is the midpoint of the foci, so that’s easy, too. For the major axis rotation angle $\theta$, you just need to find the slope of the line through the foci, which is $\tan\theta = {1-3\over4-2}=-1$, so you can take $\theta=-\pi/4$. In this case, $\tan\theta$ turned out to be one of the commonly-known values, so computing $\theta$ was easy, but observe that you don’t really need to know the angle $\theta$ explicitly to form equation (1): you need its sine and cosine, both of which can be computed from the tangent, to wit, $$\cos^2\theta = {1\over\tan^2\theta+1} = \frac12 \\ \sin^2\theta = \cos^2\theta\tan^2\theta = \frac12.$$ Choose the signs of the square roots so that $\tan\theta$ has the correct sign. Of course, we could’ve skipped computing $\tan\theta$ first and gotten the sine and cosine directly from the coordinates of the foci.
Equation (1) can be hard to remember—I always have to reconstruct it to make sure that I’ve gotten the signs right. However, observe that $-(x-h)\sin\theta+(y-k)\cos\theta=0$ is the equation of a line through $(h,k)$ with slope $\tan\theta$, i.e., it’s the major axis. Similarly, $(x-h)\cos\theta+(y-k)\sin\theta=0$ is an equation of the minor axis. I usually just work out the equations of these lines, normalize them, and then plug them in for $x$ and $y$ in the standard equation ${x^2\over a^2}+{y^2\over b^2}=1$.