Police officers resign after sexting scandal