ALMA constraints on the faint millimetre source number counts and their contribution to the cosmic infrared background