Modelling photoluminescence from small particles II. Implications for dust rotation and the extended red emission