No, it doesn't, but the water level in the second tank has to be below that in the first tank. The flow rate from the 1st to the 2nd tank will be proportional to the difference in water levels. With as small a difference as the diagram shows, the return pump will need to be throttled down to a very low flow rate to avoid overflowing the 1st tank. But, if that tank to tank water pipe is a large diameter pipe you would have a better chance.
I acknowledge that I may be wrong about this.