Equilibrium of non-neutral plasmas in a Malmberg–Penning trap with a weakly tilted magnetic field